Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 909604 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 111.0 MiB |
| Average record size in memory | 128.0 B |
Variable types
| Categorical | 2 |
|---|---|
| Numeric | 14 |
timestamp has a high cardinality: 414692 distinct values | High cardinality |
active_power_calculated_by_converter is highly correlated with active_power_raw and 7 other fields | High correlation |
active_power_raw is highly correlated with active_power_calculated_by_converter and 7 other fields | High correlation |
generator_speed is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
generator_winding_temp_max is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
grid_power10min_average is highly correlated with active_power_calculated_by_converter and 7 other fields | High correlation |
nacelle_temp is highly correlated with Target | High correlation |
reactice_power_calculated_by_converter is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
reactive_power is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
wind_speed_raw is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
wind_speed_turbulence is highly correlated with active_power_calculated_by_converter and 2 other fields | High correlation |
Target is highly correlated with nacelle_temp | High correlation |
active_power_calculated_by_converter is highly correlated with active_power_raw and 7 other fields | High correlation |
active_power_raw is highly correlated with active_power_calculated_by_converter and 7 other fields | High correlation |
generator_speed is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
generator_winding_temp_max is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
grid_power10min_average is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
nc1_inside_temp is highly correlated with nacelle_temp | High correlation |
nacelle_temp is highly correlated with nc1_inside_temp and 1 other fields | High correlation |
reactice_power_calculated_by_converter is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
reactive_power is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
wind_speed_raw is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
wind_speed_turbulence is highly correlated with active_power_calculated_by_converter and 1 other fields | High correlation |
Target is highly correlated with nacelle_temp | High correlation |
active_power_calculated_by_converter is highly correlated with active_power_raw and 5 other fields | High correlation |
active_power_raw is highly correlated with active_power_calculated_by_converter and 5 other fields | High correlation |
generator_speed is highly correlated with active_power_calculated_by_converter and 5 other fields | High correlation |
grid_power10min_average is highly correlated with active_power_calculated_by_converter and 5 other fields | High correlation |
reactice_power_calculated_by_converter is highly correlated with active_power_calculated_by_converter and 5 other fields | High correlation |
reactive_power is highly correlated with active_power_calculated_by_converter and 5 other fields | High correlation |
wind_speed_raw is highly correlated with active_power_calculated_by_converter and 5 other fields | High correlation |
active_power_calculated_by_converter is highly correlated with active_power_raw and 6 other fields | High correlation |
active_power_raw is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
ambient_temperature is highly correlated with nc1_inside_temp and 2 other fields | High correlation |
generator_speed is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
generator_winding_temp_max is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
grid_power10min_average is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
nc1_inside_temp is highly correlated with ambient_temperature and 2 other fields | High correlation |
nacelle_temp is highly correlated with ambient_temperature and 2 other fields | High correlation |
reactice_power_calculated_by_converter is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
reactive_power is highly correlated with active_power_calculated_by_converter and 6 other fields | High correlation |
wind_direction_raw is highly correlated with turbine_id | High correlation |
wind_speed_raw is highly correlated with active_power_calculated_by_converter and 7 other fields | High correlation |
wind_speed_turbulence is highly correlated with wind_speed_raw | High correlation |
turbine_id is highly correlated with ambient_temperature and 2 other fields | High correlation |
Target is highly correlated with nacelle_temp | High correlation |
timestamp is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2022-08-22 06:06:15.846808 |
|---|---|
| Analysis finished | 2022-08-22 06:10:15.606558 |
| Duration | 3 minutes and 59.76 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 414692 |
|---|---|
| Distinct (%) | 45.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| 2021-07-16 01:52:00 | 11 |
|---|---|
| 2021-08-26 10:22:00 | 11 |
| 2021-06-03 19:57:00 | 11 |
| 2021-04-02 21:49:00 | 11 |
| 2021-08-24 16:10:00 | 10 |
| Other values (414687) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 17282476 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 140047 ? |
|---|---|
| Unique (%) | 15.4% |
Sample
| 1st row | 2021-02-19 20:18:00 |
|---|---|
| 2nd row | 2021-04-27 04:55:00 |
| 3rd row | 2021-01-25 06:26:00 |
| 4th row | 2021-10-30 03:47:00 |
| 5th row | 2021-03-15 00:39:00 |
Common Values
| Value | Count | Frequency (%) |
| 2021-07-16 01:52:00 | 11 | < 0.1% |
| 2021-08-26 10:22:00 | 11 | < 0.1% |
| 2021-06-03 19:57:00 | 11 | < 0.1% |
| 2021-04-02 21:49:00 | 11 | < 0.1% |
| 2021-08-24 16:10:00 | 10 | < 0.1% |
| 2021-03-12 11:18:00 | 10 | < 0.1% |
| 2021-06-25 02:59:00 | 10 | < 0.1% |
| 2021-09-08 20:58:00 | 10 | < 0.1% |
| 2021-09-08 20:53:00 | 10 | < 0.1% |
| 2021-09-29 01:04:00 | 10 | < 0.1% |
| Other values (414682) | 909500 |
Length
| Value | Count | Frequency (%) |
| 2021-12-31 | 2941 | 0.2% |
| 2021-12-17 | 2928 | 0.2% |
| 2021-12-20 | 2910 | 0.2% |
| 2021-12-29 | 2909 | 0.2% |
| 2021-07-22 | 2907 | 0.2% |
| 2021-07-24 | 2903 | 0.2% |
| 2021-04-05 | 2901 | 0.2% |
| 2021-11-22 | 2901 | 0.2% |
| 2021-06-07 | 2900 | 0.2% |
| 2021-07-26 | 2896 | 0.2% |
| Other values (1794) | 1790112 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4604875 | |
| 2 | 2849055 | |
| 1 | 2400066 | |
| - | 1819208 | 10.5% |
| : | 1819208 | 10.5% |
| 909604 | 5.3% | |
| 3 | 567190 | 3.3% |
| 5 | 484736 | 2.8% |
| 4 | 478033 | 2.8% |
| 7 | 344237 | 2.0% |
| Other values (3) | 1006264 | 5.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 12734456 | |
| Dash Punctuation | 1819208 | 10.5% |
| Other Punctuation | 1819208 | 10.5% |
| Space Separator | 909604 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4604875 | |
| 2 | 2849055 | |
| 1 | 2400066 | |
| 3 | 567190 | 4.5% |
| 5 | 484736 | 3.8% |
| 4 | 478033 | 3.8% |
| 7 | 344237 | 2.7% |
| 8 | 341119 | 2.7% |
| 6 | 339511 | 2.7% |
| 9 | 325634 | 2.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1819208 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 1819208 |
Space Separator
| Value | Count | Frequency (%) |
| 909604 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 17282476 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 4604875 | |
| 2 | 2849055 | |
| 1 | 2400066 | |
| - | 1819208 | 10.5% |
| : | 1819208 | 10.5% |
| 909604 | 5.3% | |
| 3 | 567190 | 3.3% |
| 5 | 484736 | 2.8% |
| 4 | 478033 | 2.8% |
| 7 | 344237 | 2.0% |
| Other values (3) | 1006264 | 5.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 17282476 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 4604875 | |
| 2 | 2849055 | |
| 1 | 2400066 | |
| - | 1819208 | 10.5% |
| : | 1819208 | 10.5% |
| 909604 | 5.3% | |
| 3 | 567190 | 3.3% |
| 5 | 484736 | 2.8% |
| 4 | 478033 | 2.8% |
| 7 | 344237 | 2.0% |
| Other values (3) | 1006264 | 5.8% |
active_power_calculated_by_converter
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 908574 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 525.8860615 |
| Minimum | 0 |
|---|---|
| Maximum | 1999.999858 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 22.30054725 |
| Q1 | 149.6208982 |
| median | 379.9899292 |
| Q3 | 781.3574753 |
| 95-th percentile | 1519.630602 |
| Maximum | 1999.999858 |
| Range | 1999.999858 |
| Interquartile range (IQR) | 631.736577 |
Descriptive statistics
| Standard deviation | 474.6195757 |
|---|---|
| Coefficient of variation (CV) | 0.9025140815 |
| Kurtosis | 0.4610637422 |
| Mean | 525.8860615 |
| Median Absolute Deviation (MAD) | 278.2603669 |
| Skewness | 1.094893808 |
| Sum | 478348065.1 |
| Variance | 225263.7417 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 372.3947703 | 3 | < 0.1% |
| 382.1980794 | 3 | < 0.1% |
| 807.5866903 | 2 | < 0.1% |
| 340.7234446 | 2 | < 0.1% |
| 318.3548381 | 2 | < 0.1% |
| 317.4683787 | 2 | < 0.1% |
| 1002.183228 | 2 | < 0.1% |
| 482.0493469 | 2 | < 0.1% |
| 217.0893377 | 2 | < 0.1% |
| 262.7181193 | 2 | < 0.1% |
| Other values (908564) | 909582 |
| Value | Count | Frequency (%) |
| 0 | 2 | |
| 1.42424793 × 10-5 | 1 | |
| 2.624800363 × 10-5 | 1 | |
| 3.169228633 × 10-5 | 1 | |
| 4.995862643 × 10-5 | 1 | |
| 5.025905229 × 10-5 | 1 | |
| 6.226457662 × 10-5 | 1 | |
| 0.0001035717626 | 1 | |
| 0.0001102866739 | 1 | |
| 0.0002590948716 | 1 |
| Value | Count | Frequency (%) |
| 1999.999858 | 1 | |
| 1999.998922 | 1 | |
| 1999.998128 | 1 | |
| 1999.994751 | 1 | |
| 1999.993815 | 1 | |
| 1999.990214 | 1 | |
| 1999.975627 | 1 | |
| 1999.966634 | 1 | |
| 1999.957007 | 1 | |
| 1999.954624 | 1 |
active_power_raw
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 908591 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 537.6394682 |
| Minimum | 8.443594197 × 10-6 |
|---|---|
| Maximum | 1999.984456 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 8.443594197 × 10-6 |
|---|---|
| 5-th percentile | 25.9436022 |
| Q1 | 155.8132439 |
| median | 383.9859263 |
| Q3 | 800.2611084 |
| 95-th percentile | 1557.439565 |
| Maximum | 1999.984456 |
| Range | 1999.984448 |
| Interquartile range (IQR) | 644.4478645 |
Descriptive statistics
| Standard deviation | 482.3949074 |
|---|---|
| Coefficient of variation (CV) | 0.897246084 |
| Kurtosis | 0.356481929 |
| Mean | 537.6394682 |
| Median Absolute Deviation (MAD) | 276.578481 |
| Skewness | 1.079559874 |
| Sum | 489039010.8 |
| Variance | 232704.8467 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 855.3696798 | 3 | < 0.1% |
| 365.5632426 | 3 | < 0.1% |
| 306.0512085 | 2 | < 0.1% |
| 652.5406189 | 2 | < 0.1% |
| 208.5755386 | 2 | < 0.1% |
| 216.3026047 | 2 | < 0.1% |
| 674.662618 | 2 | < 0.1% |
| 1153.872213 | 2 | < 0.1% |
| 342.6287587 | 2 | < 0.1% |
| 561.5646871 | 2 | < 0.1% |
| Other values (908581) | 909582 |
| Value | Count | Frequency (%) |
| 8.443594197 × 10-6 | 1 | |
| 0.0001308560313 | 1 | |
| 0.0001439666812 | 1 | |
| 0.0004366234061 | 1 | |
| 0.0004378785088 | 1 | |
| 0.0004684340965 | 1 | |
| 0.0005602171877 | 1 | |
| 0.0006281003589 | 1 | |
| 0.0006815028028 | 1 | |
| 0.000718610303 | 1 |
| Value | Count | Frequency (%) |
| 1999.984456 | 1 | |
| 1999.95109 | 1 | |
| 1999.940491 | 1 | |
| 1999.93866 | 1 | |
| 1999.914612 | 1 | |
| 1999.869954 | 1 | |
| 1999.833761 | 1 | |
| 1999.766744 | 1 | |
| 1999.740662 | 1 | |
| 1999.724243 | 1 |
| Distinct | 902272 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.57392143 |
| Minimum | 5.616541386 |
|---|---|
| Maximum | 48.08901672 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 5.616541386 |
|---|---|
| 5-th percentile | 12.24757375 |
| Q1 | 17.09367959 |
| median | 27.91903458 |
| Q3 | 32.17169571 |
| 95-th percentile | 35.52602758 |
| Maximum | 48.08901672 |
| Range | 42.47247534 |
| Interquartile range (IQR) | 15.07801612 |
Descriptive statistics
| Standard deviation | 8.025649303 |
|---|---|
| Coefficient of variation (CV) | 0.3138216142 |
| Kurtosis | -1.102809748 |
| Mean | 25.57392143 |
| Median Absolute Deviation (MAD) | 5.354522864 |
| Skewness | -0.4056062668 |
| Sum | 23262141.22 |
| Variance | 64.41104673 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33.06497955 | 4 | < 0.1% |
| 34.02183533 | 4 | < 0.1% |
| 31.60770988 | 3 | < 0.1% |
| 32.08332443 | 3 | < 0.1% |
| 33.71655273 | 3 | < 0.1% |
| 32.0236702 | 3 | < 0.1% |
| 33.12687302 | 3 | < 0.1% |
| 26.4209671 | 3 | < 0.1% |
| 33.70933151 | 3 | < 0.1% |
| 12.6002903 | 3 | < 0.1% |
| Other values (902262) | 909572 |
| Value | Count | Frequency (%) |
| 5.616541386 | 1 | |
| 5.636572838 | 1 | |
| 5.657158852 | 1 | |
| 5.67549336 | 1 | |
| 5.678601265 | 1 | |
| 5.687244415 | 1 | |
| 5.69017458 | 1 | |
| 5.693353971 | 1 | |
| 5.702694654 | 1 | |
| 5.715754032 | 1 |
| Value | Count | Frequency (%) |
| 48.08901672 | 1 | |
| 47.95053279 | 1 | |
| 47.9408493 | 1 | |
| 47.90762138 | 1 | |
| 47.87809181 | 1 | |
| 47.82300472 | 1 | |
| 47.82160187 | 1 | |
| 47.80286407 | 1 | |
| 47.78376102 | 1 | |
| 47.697052 | 1 |
generator_speed
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 102172 |
|---|---|
| Distinct (%) | 11.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 931.1308817 |
| Minimum | 0 |
|---|---|
| Maximum | 1267.140625 |
| Zeros | 100 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 761.0166931 |
| Q1 | 770.5385742 |
| median | 884.0685018 |
| Q3 | 1123.335856 |
| 95-th percentile | 1200.243164 |
| Maximum | 1267.140625 |
| Range | 1267.140625 |
| Interquartile range (IQR) | 352.7972819 |
Descriptive statistics
| Standard deviation | 193.6743836 |
|---|---|
| Coefficient of variation (CV) | 0.2079990981 |
| Kurtosis | 1.561075179 |
| Mean | 931.1308817 |
| Median Absolute Deviation (MAD) | 114.4377035 |
| Skewness | -0.4328699721 |
| Sum | 846960374.5 |
| Variance | 37509.76685 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 769.8061218 | 36916 | 4.1% |
| 770.5385742 | 24665 | 2.7% |
| 769.0736694 | 14186 | 1.6% |
| 770.0502726 | 14114 | 1.6% |
| 769.561971 | 12371 | 1.4% |
| 769.9526123 | 9257 | 1.0% |
| 770.2455933 | 8679 | 1.0% |
| 769.6596313 | 8110 | 0.9% |
| 770.172348 | 7482 | 0.8% |
| 769.3666504 | 5087 | 0.6% |
| Other values (102162) | 768737 |
| Value | Count | Frequency (%) |
| 0 | 100 | |
| 2.384185791 × 10-8 | 1 | < 0.1% |
| 8.514949254 × 10-8 | 1 | < 0.1% |
| 9.934107463 × 10-8 | 2 | < 0.1% |
| 1.192092896 × 10-7 | 4 | < 0.1% |
| 1.682954676 × 10-7 | 1 | < 0.1% |
| 1.788139343 × 10-7 | 1 | < 0.1% |
| 2.58286794 × 10-7 | 1 | < 0.1% |
| 3.973642985 × 10-7 | 2 | < 0.1% |
| 0.00145616529 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1267.140625 | 1 | |
| 1241.103489 | 1 | |
| 1237.109985 | 1 | |
| 1232.424443 | 1 | |
| 1230.028152 | 1 | |
| 1227.667542 | 1 | |
| 1225.306931 | 1 | |
| 1223.745398 | 1 | |
| 1222.94632 | 1 | |
| 1220.585709 | 1 |
| Distinct | 902324 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 60.73011204 |
| Minimum | 25.63636557 |
|---|---|
| Maximum | 129.846405 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 25.63636557 |
|---|---|
| 5-th percentile | 45.65135899 |
| Q1 | 54.91676693 |
| median | 60.03448963 |
| Q3 | 65.73718719 |
| 95-th percentile | 78.44303102 |
| Maximum | 129.846405 |
| Range | 104.2100395 |
| Interquartile range (IQR) | 10.82042027 |
Descriptive statistics
| Standard deviation | 9.72158221 |
|---|---|
| Coefficient of variation (CV) | 0.1600784501 |
| Kurtosis | 1.217988071 |
| Mean | 60.73011204 |
| Median Absolute Deviation (MAD) | 5.382360649 |
| Skewness | 0.482790834 |
| Sum | 55240352.83 |
| Variance | 94.50916066 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 55.40732002 | 3 | < 0.1% |
| 54.57275518 | 3 | < 0.1% |
| 72.41700363 | 3 | < 0.1% |
| 72.9152298 | 3 | < 0.1% |
| 64.01242065 | 3 | < 0.1% |
| 60.86440214 | 3 | < 0.1% |
| 69.58611298 | 3 | < 0.1% |
| 57.78290685 | 3 | < 0.1% |
| 68.44352722 | 3 | < 0.1% |
| 55.46962547 | 3 | < 0.1% |
| Other values (902314) | 909574 |
| Value | Count | Frequency (%) |
| 25.63636557 | 1 | |
| 25.84215736 | 1 | |
| 25.9289252 | 1 | |
| 25.97074763 | 1 | |
| 26.03799502 | 1 | |
| 26.19431343 | 1 | |
| 26.20442931 | 1 | |
| 26.23410384 | 1 | |
| 26.26274077 | 1 | |
| 26.27723185 | 1 |
| Value | Count | Frequency (%) |
| 129.846405 | 1 | |
| 129.7985331 | 1 | |
| 128.937735 | 1 | |
| 128.7516571 | 1 | |
| 127.7782974 | 1 | |
| 127.574324 | 1 | |
| 124.713239 | 1 | |
| 121.9265238 | 1 | |
| 120.2522964 | 1 | |
| 117.7123337 | 1 |
grid_power10min_average
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 908371 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 527.5795372 |
| Minimum | 0 |
|---|---|
| Maximum | 1999.991455 |
| Zeros | 23 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.998432296 |
| Q1 | 147.1815516 |
| median | 391.3031871 |
| Q3 | 794.8757095 |
| 95-th percentile | 1507.971682 |
| Maximum | 1999.991455 |
| Range | 1999.991455 |
| Interquartile range (IQR) | 647.6941579 |
Descriptive statistics
| Standard deviation | 472.6569764 |
|---|---|
| Coefficient of variation (CV) | 0.8958970982 |
| Kurtosis | 0.2352332911 |
| Mean | 527.5795372 |
| Median Absolute Deviation (MAD) | 291.3128173 |
| Skewness | 1.00806151 |
| Sum | 479888457.3 |
| Variance | 223404.6174 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 23 | < 0.1% |
| 299.8139547 | 2 | < 0.1% |
| 603.1001282 | 2 | < 0.1% |
| 100.0304171 | 2 | < 0.1% |
| 948.8134766 | 2 | < 0.1% |
| 530.8165385 | 2 | < 0.1% |
| 466.2781677 | 2 | < 0.1% |
| 50.04200872 | 2 | < 0.1% |
| 636.4330444 | 2 | < 0.1% |
| 489.1442769 | 2 | < 0.1% |
| Other values (908361) | 909563 |
| Value | Count | Frequency (%) |
| 0 | 23 | |
| 0.0004185040792 | 1 | < 0.1% |
| 0.0004504318349 | 1 | < 0.1% |
| 0.0004868494968 | 1 | < 0.1% |
| 0.0006019473076 | 1 | < 0.1% |
| 0.001118829937 | 1 | < 0.1% |
| 0.001278515905 | 1 | < 0.1% |
| 0.001291538278 | 1 | < 0.1% |
| 0.001374113063 | 1 | < 0.1% |
| 0.001388296485 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1999.991455 | 1 | |
| 1999.985311 | 1 | |
| 1999.943542 | 1 | |
| 1999.941284 | 1 | |
| 1999.940938 | 1 | |
| 1999.939067 | 1 | |
| 1999.936808 | 1 | |
| 1999.936381 | 1 | |
| 1999.936178 | 1 | |
| 1999.931051 | 1 |
| Distinct | 889309 |
|---|---|
| Distinct (%) | 97.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.75582325 |
| Minimum | 11.14192224 |
|---|---|
| Maximum | 52.79003016 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 11.14192224 |
|---|---|
| 5-th percentile | 26.07736015 |
| Q1 | 29.91380334 |
| median | 31.76294597 |
| Q3 | 33.46974513 |
| 95-th percentile | 38.55420765 |
| Maximum | 52.79003016 |
| Range | 41.64810793 |
| Interquartile range (IQR) | 3.555941788 |
Descriptive statistics
| Standard deviation | 3.929794339 |
|---|---|
| Coefficient of variation (CV) | 0.1237503531 |
| Kurtosis | 4.299023904 |
| Mean | 31.75582325 |
| Median Absolute Deviation (MAD) | 1.768719832 |
| Skewness | 0.04052958733 |
| Sum | 28885223.85 |
| Variance | 15.44328355 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33.72241592 | 5 | < 0.1% |
| 33.52302551 | 5 | < 0.1% |
| 33.41698837 | 5 | < 0.1% |
| 33.12144089 | 5 | < 0.1% |
| 32.82253265 | 5 | < 0.1% |
| 33.92132568 | 5 | < 0.1% |
| 30.61693954 | 4 | < 0.1% |
| 32.91983795 | 4 | < 0.1% |
| 32.23236465 | 4 | < 0.1% |
| 33.25991058 | 4 | < 0.1% |
| Other values (889299) | 909558 |
| Value | Count | Frequency (%) |
| 11.14192224 | 1 | |
| 11.14983622 | 1 | |
| 11.1915555 | 1 | |
| 11.20882916 | 1 | |
| 11.21199799 | 1 | |
| 11.21314526 | 1 | |
| 11.21486982 | 1 | |
| 11.25723012 | 1 | |
| 11.26071215 | 1 | |
| 11.28142977 | 1 |
| Value | Count | Frequency (%) |
| 52.79003016 | 1 | |
| 52.54673513 | 1 | |
| 52.5359436 | 1 | |
| 52.51416985 | 1 | |
| 52.51406479 | 1 | |
| 52.50380707 | 1 | |
| 52.48160458 | 1 | |
| 52.42815018 | 1 | |
| 52.38589605 | 1 | |
| 52.30387115 | 1 |
| Distinct | 886877 |
|---|---|
| Distinct (%) | 97.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.68641306 |
| Minimum | 16.01021767 |
|---|---|
| Maximum | 48.40610631 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 16.01021767 |
|---|---|
| 5-th percentile | 24.85664759 |
| Q1 | 30.26742258 |
| median | 31.96161008 |
| Q3 | 33.54625975 |
| 95-th percentile | 36.98366802 |
| Maximum | 48.40610631 |
| Range | 32.39588865 |
| Interquartile range (IQR) | 3.278837172 |
Descriptive statistics
| Standard deviation | 3.55442601 |
|---|---|
| Coefficient of variation (CV) | 0.1121750828 |
| Kurtosis | 1.922251785 |
| Mean | 31.68641306 |
| Median Absolute Deviation (MAD) | 1.635901848 |
| Skewness | -0.4275419016 |
| Sum | 28822088.07 |
| Variance | 12.63394426 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 32.82194138 | 6 | < 0.1% |
| 32.22176361 | 5 | < 0.1% |
| 32.22185898 | 5 | < 0.1% |
| 31.12330437 | 5 | < 0.1% |
| 32.82828903 | 5 | < 0.1% |
| 29.52427101 | 5 | < 0.1% |
| 32.22238541 | 5 | < 0.1% |
| 32.32689667 | 5 | < 0.1% |
| 33.22154617 | 5 | < 0.1% |
| 32.52181244 | 5 | < 0.1% |
| Other values (886867) | 909553 |
| Value | Count | Frequency (%) |
| 16.01021767 | 1 | |
| 16.02101405 | 1 | |
| 16.30211703 | 1 | |
| 16.30954266 | 1 | |
| 16.38340696 | 1 | |
| 16.61210823 | 1 | |
| 16.64102205 | 1 | |
| 16.65616131 | 1 | |
| 16.69316559 | 1 | |
| 16.70379829 | 1 |
| Value | Count | Frequency (%) |
| 48.40610631 | 1 | |
| 48.391915 | 1 | |
| 48.37772369 | 1 | |
| 48.31995773 | 1 | |
| 48.26211014 | 1 | |
| 48.23487091 | 1 | |
| 48.23030472 | 1 | |
| 48.22573853 | 1 | |
| 48.22345161 | 1 | |
| 48.20982552 | 1 |
reactice_power_calculated_by_converter
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 905428 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 111.0806104 |
| Minimum | -318.3937215 |
|---|---|
| Maximum | 523.8926951 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 13954 |
| Negative (%) | 1.5% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | -318.3937215 |
|---|---|
| 5-th percentile | 2.048212675 |
| Q1 | 81.54084953 |
| median | 92.00582631 |
| Q3 | 124.8791529 |
| 95-th percentile | 278.1797583 |
| Maximum | 523.8926951 |
| Range | 842.2864166 |
| Interquartile range (IQR) | 43.33830341 |
Descriptive statistics
| Standard deviation | 78.21994359 |
|---|---|
| Coefficient of variation (CV) | 0.7041727923 |
| Kurtosis | 4.080529096 |
| Mean | 111.0806104 |
| Median Absolute Deviation (MAD) | 19.8386062 |
| Skewness | 1.731298225 |
| Sum | 101039367.5 |
| Variance | 6118.359575 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 87.39230347 | 3 | < 0.1% |
| 86.8408254 | 3 | < 0.1% |
| 91.34537633 | 3 | < 0.1% |
| 84.80268097 | 3 | < 0.1% |
| 90.39906693 | 3 | < 0.1% |
| 100.6307983 | 3 | < 0.1% |
| 93.83218511 | 3 | < 0.1% |
| 93.17549006 | 3 | < 0.1% |
| 116.6873728 | 3 | < 0.1% |
| 86.09453456 | 3 | < 0.1% |
| Other values (905418) | 909574 |
| Value | Count | Frequency (%) |
| -318.3937215 | 1 | |
| -302.0977715 | 1 | |
| -293.9497965 | 1 | |
| -164.9461876 | 1 | |
| -159.9429789 | 1 | |
| -134.9269357 | 1 | |
| -129.923727 | 1 | |
| -108.5203747 | 1 | |
| -70.55269953 | 1 | |
| -63.61061028 | 1 |
| Value | Count | Frequency (%) |
| 523.8926951 | 1 | |
| 522.6970673 | 1 | |
| 520.7262319 | 1 | |
| 519.5677795 | 1 | |
| 511.5276235 | 1 | |
| 510.690333 | 1 | |
| 510.3043009 | 1 | |
| 508.6128489 | 1 | |
| 508.6007131 | 1 | |
| 508.3623861 | 1 |
| Distinct | 903958 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 133.6923334 |
| Minimum | -5.46160717 |
|---|---|
| Maximum | 592.8159383 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Negative | 11849 |
| Negative (%) | 1.3% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | -5.46160717 |
|---|---|
| 5-th percentile | 1.722649301 |
| Q1 | 96.04576461 |
| median | 107.6333777 |
| Q3 | 154.1537304 |
| 95-th percentile | 329.3071905 |
| Maximum | 592.8159383 |
| Range | 598.2775455 |
| Interquartile range (IQR) | 58.10796579 |
Descriptive statistics
| Standard deviation | 91.23215183 |
|---|---|
| Coefficient of variation (CV) | 0.6824037665 |
| Kurtosis | 3.537841443 |
| Mean | 133.6923334 |
| Median Absolute Deviation (MAD) | 28.14022832 |
| Skewness | 1.638331752 |
| Sum | 121607081.2 |
| Variance | 8323.305527 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5.605193857 × 10-45 | 121 | < 0.1% |
| -5.605193857 × 10-45 | 7 | < 0.1% |
| 0 | 5 | < 0.1% |
| 95.40774918 | 4 | < 0.1% |
| 95.07298279 | 4 | < 0.1% |
| 100.135245 | 3 | < 0.1% |
| 97.44060516 | 3 | < 0.1% |
| 97.29464849 | 3 | < 0.1% |
| 102.1359215 | 3 | < 0.1% |
| 155.7947515 | 3 | < 0.1% |
| Other values (903948) | 909448 |
| Value | Count | Frequency (%) |
| -5.46160717 | 1 | |
| -5.305059075 | 1 | |
| -5.128311714 | 1 | |
| -5.073388179 | 1 | |
| -4.893144131 | 1 | |
| -4.876622772 | 1 | |
| -4.849861224 | 1 | |
| -4.757404168 | 1 | |
| -4.753198719 | 1 | |
| -4.746212721 | 1 |
| Value | Count | Frequency (%) |
| 592.8159383 | 1 | |
| 589.8625895 | 1 | |
| 587.5701701 | 1 | |
| 586.4319967 | 1 | |
| 585.2331034 | 1 | |
| 584.9147847 | 1 | |
| 582.5167847 | 1 | |
| 582.4387817 | 1 | |
| 582.0353597 | 1 | |
| 581.9084778 | 1 |
| Distinct | 905356 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 199.4871609 |
| Minimum | 0.3096923828 |
|---|---|
| Maximum | 359.4555308 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0.3096923828 |
|---|---|
| 5-th percentile | 24.53432315 |
| Q1 | 98.91606013 |
| median | 232.8211594 |
| Q3 | 287.6675034 |
| 95-th percentile | 336.6906916 |
| Maximum | 359.4555308 |
| Range | 359.1458384 |
| Interquartile range (IQR) | 188.7514432 |
Descriptive statistics
| Standard deviation | 104.6172613 |
|---|---|
| Coefficient of variation (CV) | 0.5244310503 |
| Kurtosis | -1.26812064 |
| Mean | 199.4871609 |
| Median Absolute Deviation (MAD) | 79.0753212 |
| Skewness | -0.3639712865 |
| Sum | 181454319.5 |
| Variance | 10944.77136 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 291.7884827 | 3 | < 0.1% |
| 282.4458923 | 3 | < 0.1% |
| 284.5333405 | 3 | < 0.1% |
| 287.9610647 | 3 | < 0.1% |
| 277.1057434 | 3 | < 0.1% |
| 277.0607147 | 3 | < 0.1% |
| 279.840154 | 3 | < 0.1% |
| 275.9653015 | 3 | < 0.1% |
| 272.3946228 | 3 | < 0.1% |
| 304.8736979 | 3 | < 0.1% |
| Other values (905346) | 909574 |
| Value | Count | Frequency (%) |
| 0.3096923828 | 1 | |
| 0.6046854655 | 1 | |
| 0.6730702718 | 1 | |
| 0.7205657959 | 1 | |
| 0.792876339 | 1 | |
| 0.8144938151 | 1 | |
| 0.8354695638 | 1 | |
| 0.9007446289 | 1 | |
| 0.906463623 | 1 | |
| 0.9138565063 | 1 |
| Value | Count | Frequency (%) |
| 359.4555308 | 1 | |
| 359.3588104 | 1 | |
| 359.3286031 | 1 | |
| 359.3163452 | 1 | |
| 359.1868591 | 1 | |
| 359.101827 | 1 | |
| 359.0842489 | 1 | |
| 359.0137126 | 1 | |
| 359.007192 | 1 | |
| 359.0047201 | 1 |
wind_speed_raw
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 823978 |
|---|---|
| Distinct (%) | 90.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.894949748 |
| Minimum | 0.9044999828 |
|---|---|
| Maximum | 19.79500071 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0.9044999828 |
|---|---|
| 5-th percentile | 3.229408822 |
| Q1 | 4.400753091 |
| median | 5.637206594 |
| Q3 | 7.092771312 |
| 95-th percentile | 9.567495966 |
| Maximum | 19.79500071 |
| Range | 18.89050073 |
| Interquartile range (IQR) | 2.692018221 |
Descriptive statistics
| Standard deviation | 1.97768399 |
|---|---|
| Coefficient of variation (CV) | 0.3354878454 |
| Kurtosis | 0.6414064659 |
| Mean | 5.894949748 |
| Median Absolute Deviation (MAD) | 1.328584154 |
| Skewness | 0.7183274163 |
| Sum | 5362069.87 |
| Variance | 3.911233963 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5.576200008 | 33 | < 0.1% |
| 5.551428556 | 32 | < 0.1% |
| 5.615542889 | 31 | < 0.1% |
| 5.531028589 | 31 | < 0.1% |
| 5.590771437 | 29 | < 0.1% |
| 5.48002855 | 29 | < 0.1% |
| 5.401342869 | 27 | < 0.1% |
| 5.573285739 | 27 | < 0.1% |
| 5.427571456 | 26 | < 0.1% |
| 5.513542891 | 25 | < 0.1% |
| Other values (823968) | 909314 |
| Value | Count | Frequency (%) |
| 0.9044999828 | 1 | |
| 0.9045000076 | 1 | |
| 0.9082222382 | 1 | |
| 0.9138055543 | 1 | |
| 0.9156666597 | 1 | |
| 0.917527775 | 1 | |
| 0.9201333404 | 1 | |
| 0.9212499857 | 1 | |
| 0.9221805433 | 1 | |
| 0.9223666668 | 1 |
| Value | Count | Frequency (%) |
| 19.79500071 | 1 | |
| 19.78999996 | 1 | |
| 19.78916709 | 1 | |
| 19.78416697 | 1 | |
| 19.77716797 | 1 | |
| 19.77166716 | 1 | |
| 19.77166684 | 1 | |
| 19.73503748 | 1 | |
| 19.65077651 | 1 | |
| 19.6233333 | 1 |
| Distinct | 906984 |
|---|---|
| Distinct (%) | 99.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6519156608 |
| Minimum | 0 |
|---|---|
| Maximum | 9.534769058 |
| Zeros | 22 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.28687598 |
| Q1 | 0.4321290081 |
| median | 0.5838627726 |
| Q3 | 0.798239775 |
| 95-th percentile | 1.232609609 |
| Maximum | 9.534769058 |
| Range | 9.534769058 |
| Interquartile range (IQR) | 0.3661107669 |
Descriptive statistics
| Standard deviation | 0.3175132374 |
|---|---|
| Coefficient of variation (CV) | 0.4870464947 |
| Kurtosis | 15.8708017 |
| Mean | 0.6519156608 |
| Median Absolute Deviation (MAD) | 0.1738885467 |
| Skewness | 2.20547233 |
| Sum | 592985.0927 |
| Variance | 0.1008146559 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 22 | < 0.1% |
| 0.7860261798 | 3 | < 0.1% |
| 0.2912351787 | 3 | < 0.1% |
| 0.4777240157 | 3 | < 0.1% |
| 0.5640664101 | 3 | < 0.1% |
| 0.6193181872 | 3 | < 0.1% |
| 0.7434059978 | 3 | < 0.1% |
| 0.5281896989 | 3 | < 0.1% |
| 0.7173552513 | 3 | < 0.1% |
| 0.7430378795 | 3 | < 0.1% |
| Other values (906974) | 909555 |
| Value | Count | Frequency (%) |
| 0 | 22 | |
| 7.770637877 × 10-5 | 1 | < 0.1% |
| 0.0001554127575 | 1 | < 0.1% |
| 0.000364114108 | 1 | < 0.1% |
| 0.0004662382726 | 1 | < 0.1% |
| 0.0007923971787 | 1 | < 0.1% |
| 0.001206299297 | 1 | < 0.1% |
| 0.002251466242 | 1 | < 0.1% |
| 0.00247778904 | 1 | < 0.1% |
| 0.003618897891 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.534769058 | 1 | |
| 9.041450659 | 1 | |
| 8.775206375 | 1 | |
| 8.642719905 | 1 | |
| 8.428555171 | 1 | |
| 8.247622649 | 1 | |
| 7.914759159 | 1 | |
| 7.514018218 | 1 | |
| 7.260570685 | 1 | |
| 7.154025841 | 1 |
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.9 MiB |
| Turbine_15 | 58048 |
|---|---|
| Turbine_18 | 57892 |
| Turbine_120 | 57754 |
| Turbine_97 | 57683 |
| Turbine_158 | 57470 |
| Other values (11) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 10.43982326 |
| Min length | 10 |
Characters and Unicode
| Total characters | 9496105 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Turbine_108 |
|---|---|
| 2nd row | Turbine_18 |
| 3rd row | Turbine_105 |
| 4th row | Turbine_15 |
| 5th row | Turbine_01 |
Common Values
| Value | Count | Frequency (%) |
| Turbine_15 | 58048 | 6.4% |
| Turbine_18 | 57892 | 6.4% |
| Turbine_120 | 57754 | 6.3% |
| Turbine_97 | 57683 | 6.3% |
| Turbine_158 | 57470 | 6.3% |
| Turbine_108 | 57401 | 6.3% |
| Turbine_105 | 57341 | 6.3% |
| Turbine_103 | 56944 | 6.3% |
| Turbine_14 | 56934 | 6.3% |
| Turbine_139 | 56930 | 6.3% |
| Other values (6) | 335207 |
Length
| Value | Count | Frequency (%) |
| turbine_15 | 58048 | 6.4% |
| turbine_18 | 57892 | 6.4% |
| turbine_120 | 57754 | 6.3% |
| turbine_97 | 57683 | 6.3% |
| turbine_158 | 57470 | 6.3% |
| turbine_108 | 57401 | 6.3% |
| turbine_105 | 57341 | 6.3% |
| turbine_103 | 56944 | 6.3% |
| turbine_14 | 56934 | 6.3% |
| turbine_139 | 56930 | 6.3% |
| Other values (6) | 335207 |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 909604 | |
| u | 909604 | |
| r | 909604 | |
| b | 909604 | |
| i | 909604 | |
| n | 909604 | |
| e | 909604 | |
| _ | 909604 | |
| 1 | 795398 | |
| 0 | 395223 | 4.2% |
| Other values (7) | 1028652 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5457624 | |
| Decimal Number | 2219273 | |
| Uppercase Letter | 909604 | 9.6% |
| Connector Punctuation | 909604 | 9.6% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 795398 | |
| 0 | 395223 | |
| 3 | 226952 | 10.2% |
| 5 | 172859 | 7.8% |
| 8 | 172763 | 7.8% |
| 9 | 170959 | 7.7% |
| 2 | 170502 | 7.7% |
| 7 | 57683 | 2.6% |
| 4 | 56934 | 2.6% |
Lowercase Letter
| Value | Count | Frequency (%) |
| u | 909604 | |
| r | 909604 | |
| b | 909604 | |
| i | 909604 | |
| n | 909604 | |
| e | 909604 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 909604 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 909604 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6367228 | |
| Common | 3128877 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| _ | 909604 | |
| 1 | 795398 | |
| 0 | 395223 | |
| 3 | 226952 | 7.3% |
| 5 | 172859 | 5.5% |
| 8 | 172763 | 5.5% |
| 9 | 170959 | 5.5% |
| 2 | 170502 | 5.4% |
| 7 | 57683 | 1.8% |
| 4 | 56934 | 1.8% |
Latin
| Value | Count | Frequency (%) |
| T | 909604 | |
| u | 909604 | |
| r | 909604 | |
| b | 909604 | |
| i | 909604 | |
| n | 909604 | |
| e | 909604 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9496105 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 909604 | |
| u | 909604 | |
| r | 909604 | |
| b | 909604 | |
| i | 909604 | |
| n | 909604 | |
| e | 909604 | |
| _ | 909604 | |
| 1 | 795398 | |
| 0 | 395223 | 4.2% |
| Other values (7) | 1028652 |
| Distinct | 861262 |
|---|---|
| Distinct (%) | 94.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46.3285948 |
| Minimum | 25.86532021 |
|---|---|
| Maximum | 65.03768921 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 6.9 MiB |
Quantile statistics
| Minimum | 25.86532021 |
|---|---|
| 5-th percentile | 42.26528721 |
| Q1 | 44.81674027 |
| median | 46.3028986 |
| Q3 | 47.73310494 |
| 95-th percentile | 50.04729681 |
| Maximum | 65.03768921 |
| Range | 39.172369 |
| Interquartile range (IQR) | 2.91636467 |
Descriptive statistics
| Standard deviation | 2.617691223 |
|---|---|
| Coefficient of variation (CV) | 0.05650271143 |
| Kurtosis | 3.915566828 |
| Mean | 46.3285948 |
| Median Absolute Deviation (MAD) | 1.464714766 |
| Skewness | 0.7053594019 |
| Sum | 42140675.14 |
| Variance | 6.852307337 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 46.52188873 | 6 | < 0.1% |
| 45.71483231 | 5 | < 0.1% |
| 44.19623947 | 5 | < 0.1% |
| 45.61221313 | 5 | < 0.1% |
| 46.33068085 | 5 | < 0.1% |
| 45.31155777 | 5 | < 0.1% |
| 48.02175903 | 5 | < 0.1% |
| 48.42476654 | 5 | < 0.1% |
| 45.92194366 | 5 | < 0.1% |
| 47.01654434 | 5 | < 0.1% |
| Other values (861252) | 909553 |
| Value | Count | Frequency (%) |
| 25.86532021 | 1 | |
| 25.95477359 | 1 | |
| 26.02581912 | 1 | |
| 26.28480339 | 1 | |
| 26.50784016 | 1 | |
| 26.52709627 | 1 | |
| 26.7042764 | 1 | |
| 26.78308964 | 1 | |
| 26.79018275 | 1 | |
| 26.80436897 | 1 |
| Value | Count | Frequency (%) |
| 65.03768921 | 1 | |
| 65.0255661 | 1 | |
| 65.02304077 | 1 | |
| 65.01832123 | 1 | |
| 65.0173378 | 1 | |
| 65.01710281 | 1 | |
| 65.01464081 | 1 | |
| 65.00416565 | 1 | |
| 65.00361633 | 1 | |
| 64.97946167 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| timestamp | active_power_calculated_by_converter | active_power_raw | ambient_temperature | generator_speed | generator_winding_temp_max | grid_power10min_average | nc1_inside_temp | nacelle_temp | reactice_power_calculated_by_converter | reactive_power | wind_direction_raw | wind_speed_raw | wind_speed_turbulence | turbine_id | Target | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2021-02-19 20:18:00 | 816.636759 | 834.917206 | 31.694380 | 1159.616602 | 65.954214 | 917.897085 | 31.881972 | 31.504713 | 141.457644 | 165.501518 | 280.864782 | 7.057000 | 0.544082 | Turbine_108 | 47.582787 |
| 1 | 2021-04-27 04:55:00 | 419.107829 | 421.050873 | 12.894948 | 928.747996 | 59.571319 | 445.554250 | 32.423705 | 32.755770 | 89.186457 | 113.835236 | 299.552460 | 5.474937 | 0.469031 | Turbine_18 | 46.070328 |
| 2 | 2021-01-25 06:26:00 | 1303.530558 | 1337.566142 | 16.648388 | 1201.219775 | 61.270498 | 1364.716003 | 11.446849 | 18.332985 | 230.622309 | 281.452253 | 84.960106 | 8.092457 | 0.622318 | Turbine_105 | 39.989236 |
| 3 | 2021-10-30 03:47:00 | 61.494872 | 53.481008 | 28.388141 | 769.806122 | 40.674348 | 14.324897 | 34.253204 | 32.662889 | 66.211015 | 75.017531 | 87.261119 | 4.071032 | 0.760719 | Turbine_15 | 46.056587 |
| 4 | 2021-03-15 00:39:00 | 593.514364 | 611.659108 | 31.519527 | 1046.916768 | 64.341763 | 599.020172 | 32.405586 | 31.466387 | 137.163938 | 160.202421 | 313.724818 | 6.357943 | 0.346068 | Turbine_01 | 54.346095 |
| 5 | 2021-05-28 06:33:00 | 603.877940 | 620.637583 | 28.055220 | 955.604563 | 60.882138 | 697.721731 | 31.012207 | 31.054668 | 57.950467 | 75.779110 | 229.571665 | 6.026029 | 0.779887 | Turbine_15 | 47.947959 |
| 6 | 2021-01-02 01:00:00 | 282.870092 | 281.763855 | 17.984232 | 811.262878 | 47.655467 | 357.891251 | 27.033744 | 23.924233 | 81.661122 | 104.133497 | 256.913801 | 5.692431 | 0.892567 | Turbine_14 | 38.088093 |
| 7 | 2021-05-17 00:45:00 | 963.812815 | 995.340871 | 32.155075 | 1191.258521 | 68.535469 | 996.888784 | 33.537125 | 32.077898 | 177.889793 | 216.991676 | 186.539897 | 6.874557 | 1.814122 | Turbine_01 | 48.529146 |
| 8 | 2021-08-11 12:22:00 | 662.245916 | 673.992040 | 39.153615 | 1065.716431 | 60.585338 | 487.273529 | 38.906182 | 37.600506 | 121.700999 | 143.405711 | 316.731837 | 6.501520 | 0.874442 | Turbine_10 | 48.912348 |
| 9 | 2021-07-15 14:44:00 | 468.044851 | 469.828186 | 17.189911 | 876.035055 | 63.952785 | 675.510671 | 31.469155 | 33.117485 | 87.047708 | 119.317791 | 175.583277 | 4.864594 | 0.996903 | Turbine_103 | 47.616581 |
Last rows
| timestamp | active_power_calculated_by_converter | active_power_raw | ambient_temperature | generator_speed | generator_winding_temp_max | grid_power10min_average | nc1_inside_temp | nacelle_temp | reactice_power_calculated_by_converter | reactive_power | wind_direction_raw | wind_speed_raw | wind_speed_turbulence | turbine_id | Target | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 909594 | 2021-08-12 20:58:00 | 367.788884 | 369.053848 | 34.801825 | 875.592974 | 63.625823 | 502.789286 | 34.622345 | 33.852057 | 92.424756 | 110.752061 | 342.920985 | 5.409771 | 0.603152 | Turbine_10 | 48.889571 |
| 909595 | 2021-08-12 16:55:00 | 223.330709 | 214.254547 | 31.858798 | 771.830841 | 60.192288 | 388.425471 | 31.453389 | 29.520809 | 86.549025 | 100.835799 | 219.380030 | 4.910992 | 0.479672 | Turbine_97 | 46.716609 |
| 909596 | 2021-05-01 03:35:00 | 302.359060 | 296.224996 | 16.927406 | 828.433126 | 56.357490 | 343.330109 | 33.674673 | 31.719984 | 74.125481 | 104.579052 | 235.742968 | 5.334314 | 0.319832 | Turbine_123 | 45.109717 |
| 909597 | 2021-05-25 11:49:00 | 416.748281 | 416.255020 | 32.506697 | 927.038991 | 61.528378 | 353.019704 | 30.004473 | 32.241504 | 94.939171 | 117.733730 | 99.068567 | 5.722023 | 0.581206 | Turbine_108 | 47.893845 |
| 909598 | 2021-02-11 04:49:00 | 102.308385 | 92.815414 | 22.041527 | 769.630778 | 44.864599 | 150.804476 | 33.512226 | 30.560733 | 86.925824 | 98.310251 | 24.632681 | 4.705168 | 0.374873 | Turbine_103 | 46.223015 |
| 909599 | 2021-04-25 19:12:00 | 929.101908 | 948.441905 | 32.736076 | 1187.303192 | 83.187140 | 1343.320577 | 32.291391 | 35.152280 | 152.216446 | 191.088800 | 189.901812 | 7.155343 | 1.028960 | Turbine_13 | 50.768675 |
| 909600 | 2021-02-20 17:37:00 | 100.730526 | 88.694599 | 30.540500 | 770.245593 | 56.235497 | 177.620552 | 30.434302 | 29.932141 | 85.353107 | 96.621675 | 93.417590 | 4.121607 | 0.595874 | Turbine_158 | 44.234821 |
| 909601 | 2021-10-22 14:18:00 | 1120.915965 | 1165.016907 | 30.901129 | 1170.456860 | 62.942943 | 873.414622 | 30.491818 | 33.085164 | 42.820210 | 74.111173 | 230.988398 | 8.551669 | 0.951241 | Turbine_15 | 46.942486 |
| 909602 | 2021-02-08 22:03:00 | 123.444564 | 116.066919 | 32.697933 | 770.190796 | 57.245207 | 95.865704 | 32.338824 | 31.525384 | 86.549094 | 97.470984 | 65.408801 | 4.324064 | 0.247335 | Turbine_97 | 46.392221 |
| 909603 | 2021-04-09 14:28:00 | 4.843147 | 10.779734 | 19.452520 | 736.601664 | 60.603885 | 78.559767 | 30.798932 | 38.252200 | 2.763231 | 1.320198 | 11.127739 | 2.017444 | 0.963029 | Turbine_105 | 48.902180 |